Industry-standard XML support in Microsoft Office Word 2003, Microsoft Office Excel 2003, and Microsoft Office Access 2003 streamlines the process of accessing and capturing information between PCs and back-end systems, unlocking information, and allowing for the creation of integrated business solutions across the organization and between business partners.
With XML support in Excel, your data can be exposed to external processes, in a business-centric XML vocabulary.
XML enables you to organize and work with workbooks and data in ways that were previously impossible or very difficult. By using your XML schemas , you can now identify and extract specific pieces of business data from ordinary business documents.
You can attach a custom XML schema to any workbook. Then, you use the XML Source task pane to map cells to elements of the schema. Once you have mapped the XML elements to your worksheet, you can seamlessly import and export XML data into and out of the mapped cells.